Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_CUBE_MEASURE_MAPS

`ALL_OLAP2_CUBE_MEASURE_MAPS` shows the mapping of each measure to a column.

Column | Data Type | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the cube.
`CUBE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the cube.
`MEASURE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the measure contained in this cube.
`DIM_HIER_COMBO_ID` | `NUMBER` | `NOT NULL` | ID of the association between this measure and one combination of its dimension hierarchies.
`FACT_TABLE_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the fact table.
`FACT_TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the fact table.
`COLUMN_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the column in the fact table where this measure's data is stored.